SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009908 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009908 [ RunTime:0.003200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808736,199031,429485,325992,756765,459155,472686,110854,569323,895624,721140,917089,523509,537815,1026734,156501,548874,874776,22091,120895,1020637,838037,992376,682462,232798,730263,831219,142491,130032,359010,826957,882626,259275,128895,42601,816559,859104,712277,449733,257753,1019642,758831,836800,755779,644249,329656,630583,1002833,86754,61679,139678,785723,273170,314892,653294,920503,898857,494871,353547,395340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]