SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32840 LIMIT 1 [ RunTime:0.000607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32840 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597288,127344,920097,948685,810165,129711,767375,597149,312805,270712,463659,92682,40340,960285,315383,43256,831020,1036917,512359,555550,531542,320642,122976,355619,389386,884248,492241,612099,421438,443004,521848,305409,225858,339682,100202,518641,513648,89925,757758,67972,449458,611427,761180,306103,759822,977048,60051,975795,607961,462938,826790,542171,190840,219722,589970,696433,154542,92177,690873,846020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]