SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421019 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421019 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175847,1040334,39279,25996,634468,35941,379363,146665,718718,960846,282769,396894,429379,23161,626079,464037,987706,577410,80683,1003021,460020,766058,33589,315358,762838,989093,321225,118110,41668,899898,761646,432857,917482,389094,176082,365881,604559,862364,621849,62492,525996,932121,354494,289727,450106,260156,798625,618738,498585,948405,759476,330349,1906,89754,709638,478621,458415,10589,492059,553198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]