SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038789 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038789 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583791,420689,996235,453368,191840,501118,316006,112888,742680,713546,151708,700409,869449,500308,693711,889250,323289,278302,251116,154774,877509,3871,433322,75775,258451,437529,649386,79871,902271,587931,66734,45133,328404,1047120,716356,983933,974205,548775,367390,537648,1034850,219061,369677,172682,850122,591931,492977,1003298,651905,572718,383415,805876,323119,54698,679639,734152,812491,557059,916375,564771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038789 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038789 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]