SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38708 LIMIT 1 [ RunTime:0.002322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38708 [ RunTime:0.003146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398095,275977,194412,209862,935737,541894,647646,189910,20196,301106,221208,765247,964652,199883,282901,1043207,593611,719344,845187,959455,915187,599617,221120,183494,967278,1034998,427381,888779,823610,892798,434271,576871,283849,783131,581464,72471,881663,234960,144423,838208,1033141,487345,736953,227295,656779,904325,263223,958243,266957,288410,5072,424082,1007042,213446,373882,136682,801983,323386,207804,916085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]