SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53110 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53110 [ RunTime:0.003580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727010,492676,619466,1000298,408968,645996,941681,640670,704725,832819,65376,554988,606150,750133,53399,545029,544716,20552,753786,607403,514067,722408,350165,577448,16566,562640,662956,419433,342369,545434,16154,737149,577558,362076,830948,2737,1011562,615665,682304,702072,705078,1000631,902368,87340,558175,724895,485672,131224,56148,301075,212884,992516,296286,1025979,240371,964040,497403,339043,602160,992922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]