SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245093 LIMIT 1 [ RunTime:0.000546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245093 [ RunTime:0.005313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750763,665344,672835,107845,729799,386092,396961,957791,79564,528826,801098,551035,393529,986034,612037,448213,301908,611432,666586,417824,247808,1008476,829832,1037237,450002,199958,623841,756497,241946,200017,402557,359164,836328,289794,788259,586601,814842,211884,60427,577445,413891,237050,266276,230413,480196,1047533,970995,28709,1032381,539702,338978,978880,578795,56659,990497,694416,415064,388094,918632,823609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]