SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111258 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111258 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840806,299985,543230,1005004,720968,598685,278052,424824,1048790,703501,546986,225234,1020108,209883,232680,95680,750125,473135,389219,1025842,330882,836292,557246,540392,544838,180761,682762,778079,930640,701069,288883,573200,566300,219230,671946,36228,142944,183552,738541,498414,607058,684915,191948,947752,92480,535577,684500,375099,604012,881399,468416,234417,991033,97243,598117,658311,788682,268501,233090,651242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]