SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413914 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413914 [ RunTime:0.002359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110622,124936,713576,561800,1007839,313272,791179,866070,951147,613431,75697,385626,221221,965681,460189,823422,178795,422364,11187,992067,584214,202676,346679,495070,937595,257739,455640,994845,175662,59863,101041,188626,726069,526889,176381,998474,1008670,358331,61967,498216,275808,910008,612973,31441,1035296,241214,853221,770006,285094,790583,724974,722797,402502,952709,646625,392505,781854,547115,298067,52449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]