SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 71081 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 71081 [ RunTime:0.002850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666603,108135,861414,1043414,211793,1008719,878278,489031,897801,974286,940308,426999,436092,208910,665885,875619,662211,63384,355140,53399,1033017,70920,1044489,305655,610612,27987,723491,85807,955099,109781,210116,181829,559387,185247,900885,588426,904565,817492,329232,981904,738751,673990,1004655,224531,99529,405782,692091,118135,12414,39332,661051,387132,608194,187858,138040,701420,228533,605639,435234,603346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 71081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 71081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001060s ]