SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018640 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018640 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820538,320205,942684,843408,513020,139232,375142,534716,979842,398699,84458,794646,268106,930905,363244,287187,954093,776586,981983,222660,788419,1011705,855512,797457,722179,732201,492771,22725,276848,727294,368785,147771,728772,612220,29759,702766,530719,223539,174418,259711,781395,811347,745453,1036316,652342,297490,272645,836246,263170,177941,82623,200089,673487,897537,327363,974945,1003461,98879,967384,406445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001030s ]