SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521012 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521012 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48124,275318,866570,887221,435426,875770,389019,1030805,995491,989969,511003,380181,1027994,412370,513972,286130,181508,796172,367852,65951,997442,525975,492493,67997,766629,868788,799283,558898,779889,1039436,49302,924933,864290,345315,558224,1026134,4664,892080,1005434,872129,626059,907962,388533,435365,42771,298910,245567,254396,326591,629575,986697,66412,179573,845493,585193,526088,1023354,666326,949510,36929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]