SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534917 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534917 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500899,482517,647811,547741,790786,258141,877478,436573,158075,793057,214719,1029960,1022759,312002,518234,443949,1048627,824835,1012298,356485,965726,354296,704229,829622,128156,828231,472740,463701,166399,351223,350666,454591,1037978,262524,85608,336507,672565,548526,1024528,603360,217414,317356,981342,123565,479001,577052,688714,48956,653044,67996,285315,124537,757746,842463,512889,470089,1015142,323129,746638,308814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]