SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313898 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313898 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733615,1021989,454501,631011,1033930,782291,693534,100948,985090,325294,858742,1039177,371903,600636,899772,634523,36129,1038916,139295,981364,325010,312263,916667,864302,246384,136999,589429,220161,370227,455348,86517,574061,155219,254810,96754,826360,521404,681300,900972,103363,27478,122457,428507,98976,932272,96336,834359,830493,235057,337121,627256,416980,505446,427191,621572,858426,802235,342655,506465,790332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]