SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569904 LIMIT 1 [ RunTime:0.002154s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569904 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452333,588102,678847,387819,499635,354431,950658,767568,780746,934874,365000,668091,173087,10673,144608,81050,478451,134144,469894,725069,998071,396443,87548,693543,8022,995965,394889,75445,828634,823732,901096,116290,244848,551474,755065,1037794,936108,542703,418080,966260,1012151,1014790,906359,226215,983774,699699,689749,335003,916911,648957,160883,482118,436166,793993,1033075,660893,282700,697119,414407,363967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]