SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533838 LIMIT 1 [ RunTime:0.003645s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533838 [ RunTime:0.004209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36584,801151,655948,1043122,912663,496086,266067,336885,554200,218579,490467,382087,591196,561308,975363,522081,965620,421192,921894,243818,350030,384630,234179,756405,927391,671351,1027819,8541,95562,417591,362250,699045,840417,1022284,135485,371682,44451,925860,733409,68641,483555,92750,790269,849946,762091,707890,20192,190772,989390,53858,363555,426453,1044726,219338,182559,98637,949518,772578,846861,613133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001729s ]