SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001890s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800412 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800412 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320176,508311,1022352,547764,833080,547846,738159,289770,362501,366516,856154,52789,137330,511020,1004180,10990,772820,1021443,650824,125068,447449,1042960,41472,351800,174073,6034,57393,653437,335244,300220,585236,247503,696036,496033,363942,686861,980211,80286,630604,215725,364813,252402,840028,1044560,294660,106628,44404,528554,600360,457333,646018,150425,596968,269281,686424,345328,200635,977712,337465,681612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]