SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514205 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514205 [ RunTime:0.002732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517750,170754,52909,868826,377976,962108,37454,731983,317569,97107,606006,1044409,921074,130823,901975,942448,87739,371252,203471,228321,144068,841044,457880,882953,87546,575846,390066,872896,85870,414346,419582,814810,272370,38647,658813,668741,423300,23742,419316,15780,942540,115962,24376,178531,994958,661692,877360,930238,413747,381710,656295,721246,42752,446448,942150,519114,391835,72031,1000143,13985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005532s ]