SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491631 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491631 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322385,257487,334673,1035564,1014442,833408,338459,282164,61767,286462,753041,248099,649759,763228,532712,403079,473123,616015,13938,29014,14201,218955,376882,561698,673650,370933,909442,729711,365679,729018,115972,485677,719082,87598,354294,486141,638226,248019,902594,330941,294500,27937,11392,912034,828669,659370,982276,31488,636483,724462,182259,750238,1045412,1022881,272345,251780,794563,673931,883016,84178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001383s ]