SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047483 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047483 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405865,353767,673768,243310,759656,944060,1045238,1048094,701123,667987,585646,687864,511585,715318,839533,417335,607357,382434,418586,569054,696367,192211,160538,271686,937974,489346,303902,972837,698279,236346,85783,146059,855931,1047975,29425,56431,54292,995520,529562,573574,453057,794512,404095,817851,345353,76729,978786,356596,136091,936815,1000220,1046155,390636,101638,245915,573347,570619,250850,81931,557293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]