SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982812 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982812 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17664,795022,79081,191782,631349,746537,541747,604506,862659,800629,120352,549702,144720,710025,335201,762438,188825,955828,99586,937389,1021732,28731,175913,914387,1000904,992509,408503,157440,491981,979460,708293,260113,1027165,114234,324095,884726,491483,874027,901997,751062,728220,34311,884741,728401,267115,845306,866879,653477,640552,264415,274737,181500,851382,885630,370958,908654,552791,587627,874542,116760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]