SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293216 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293216 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165900,73516,1020454,423179,633763,454044,947664,504612,998855,53686,566157,769866,382519,531981,126377,384213,762712,634559,593389,1001313,267133,414674,620272,158804,779791,782996,731358,266202,583089,752391,605067,1991,575380,1022464,1041743,620996,93576,211105,384014,422192,240565,156755,670037,1047797,789031,682897,111742,22543,13970,94580,344126,142456,714977,223553,916232,533740,729481,1038390,657339,1009256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]