SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104093 LIMIT 1 [ RunTime:0.000682s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104093 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036133,24467,535907,390632,808509,731725,688474,487304,1013175,400,1047502,555512,149222,33712,198361,179871,350464,1008261,570084,587399,978915,273399,273178,73123,853150,1035665,32712,224700,714093,254947,964130,744866,513349,547580,1026305,244265,988650,946702,328394,647304,695027,50141,397396,161736,450856,426102,55979,847001,670259,873037,460849,764511,965990,794484,948252,443123,796973,391421,638930,954118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001922s ]