SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271095 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271095 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240623,75426,67811,821838,900017,53278,1022184,620089,743158,167584,827252,328696,585642,134723,678740,955299,101565,1040488,133407,156932,37895,666949,397057,628568,232322,325124,60578,952922,102967,597001,784428,575394,1022834,54448,705610,776087,589803,508079,744131,344217,12475,473795,473412,333295,761608,257240,250638,92436,788237,492345,854146,384338,692983,735448,750492,25474,827114,203173,486535,701883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001327s ]