SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002002s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014151 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014151 [ RunTime:0.005174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920214,1018538,115633,306228,804061,764336,693834,356089,943500,232838,578506,132908,460592,742467,740130,22519,564766,650257,435942,446746,658658,146085,19295,785596,837978,688878,711312,527184,550442,262850,848393,533080,720934,690679,699528,922442,918440,786009,385035,505058,712745,394882,259972,1033479,583477,971658,1012646,1024716,545478,96399,866121,534007,339150,661691,526204,544267,853197,121953,1038340,997442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]