SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341205 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341205 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240334,1003566,284786,839378,233468,715228,170355,813267,44962,543742,379162,800535,632948,4878,76592,834376,934596,944207,627539,530970,301222,814322,293260,723068,248648,392736,130394,363077,101121,155318,1005198,308061,815772,301143,1026732,27086,959030,968645,956941,325071,634613,823269,229312,969856,133058,853872,506562,744363,117278,129183,488256,56037,802474,506568,522196,839254,741377,308771,1037299,889304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.039812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002111s ]