SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 970501 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 970501 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134087,62841,1018784,13387,211616,671067,294828,1026645,98158,402664,617137,361785,109402,44240,539085,486706,371506,542330,703413,716902,475648,659638,676410,353415,633113,578993,537574,494796,491380,604251,971498,261464,350157,814568,529580,877225,519072,518581,985419,269292,199544,887255,468370,207584,153013,871631,933316,1000477,424902,8901,119723,997048,675909,938580,404730,634800,231939,297411,820631,741652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 970501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 970501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]