SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014491 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014491 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394001,84607,344599,914038,348283,683629,959105,349798,452570,554025,169063,511681,975390,203074,360198,1007296,872303,427443,169127,134974,467592,239516,100302,720374,744729,1014145,91428,855282,374885,509965,312906,916683,818058,1019720,244723,676401,844177,557050,557806,1043509,828138,458584,845255,538649,521243,302081,973204,684549,653191,54247,855118,500653,326288,224668,59184,11737,282143,311844,761689,400782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]