SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 352814 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 352814 [ RunTime:0.002765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539533,56739,664520,976318,656233,926221,205802,667452,884499,605368,518304,92412,931625,95569,1045457,583680,767123,995473,911815,136182,681438,798334,418242,904627,820834,140167,940460,583982,311407,337046,1043864,449604,626580,666643,667159,71381,899380,950996,82586,691100,942167,205464,309324,582182,283927,166747,141644,927821,273206,28791,485382,236555,156501,879023,539147,291251,318800,1251,354,727670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 352814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 352814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]