SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102160 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102160 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995602,346051,610410,1027808,237840,24496,889026,645614,26633,205766,879350,476108,671693,428110,717819,595448,282187,75495,270077,140690,746750,1041549,183944,707549,314965,161568,1008422,946117,38834,927779,154484,736911,74591,608596,879299,562453,310799,744076,777510,571098,724332,170771,522449,476186,154861,32080,899104,365895,312013,342104,562413,741003,5938,79253,833116,154802,204991,857913,808744,486117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003059s ]