SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001916s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108048 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108048 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472037,158211,919049,428510,19628,902813,496815,804743,337682,270593,268064,144156,13975,985556,453869,801702,11740,647045,196268,790575,110379,253903,860807,100443,293121,538626,929870,869,735288,152515,290161,908097,465486,563629,760110,567210,979099,142754,956852,641631,1047842,873688,454033,318213,64575,287264,329605,557337,329347,345908,691115,461894,1034823,652959,864766,40577,178388,812101,349818,684789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]