SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004957s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47607 LIMIT 1 [ RunTime:0.003701s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47607 [ RunTime:0.003054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539835,521883,433021,106378,207817,49201,384128,390558,1038176,361159,174268,983777,890930,141021,778083,333842,688469,320544,108000,440140,615905,1020368,2186,802932,304125,265111,556875,3313,834050,869378,941271,159690,244084,30020,889513,197623,631748,812175,293903,975898,1001308,699392,169695,1013123,665955,326238,190134,181532,157911,848568,728092,663753,393787,1006046,490964,548849,584726,567421,308622,1033054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]