SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50511 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50511 [ RunTime:0.002726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521930,735534,689871,1039877,702361,284450,235699,960583,670141,532803,443138,912099,190422,296282,583260,377673,671919,660808,429390,198045,780497,192768,472757,902332,723191,439722,345807,241132,667957,406555,38169,130207,202232,832150,328706,834644,8945,140589,189947,462158,518057,757961,495572,132552,463220,280852,599471,362446,339932,175398,792378,864609,863604,304202,940090,643297,637835,947950,429925,797366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]