SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445410 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445410 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500162,936843,675688,329613,712343,771871,551417,405660,24666,324375,147663,952495,127044,405402,523713,860457,677425,587541,64007,976110,133849,406139,761500,1000901,281448,739232,148861,569424,865416,851578,136416,740061,40158,398273,378614,830176,53338,372174,582398,907938,95375,8141,226440,755361,119851,428688,249059,952029,769363,761266,747683,430212,542382,589044,894208,749333,1025811,574995,769670,762117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]