SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164097 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164097 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503810,845353,913374,202639,726288,1044633,317781,192860,473458,906871,373429,164072,446099,198514,728094,890463,793986,145754,1042138,444481,391962,727560,152817,903239,797674,1944,197938,362276,768679,22093,196382,496572,242623,182847,166856,645376,223265,907174,203833,954951,284406,709765,432796,196706,718015,773014,414642,185153,326766,982392,94120,240941,107089,252933,808538,234633,626753,881466,769578,106810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]