SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439416 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439416 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004379,747717,83828,111153,724249,648309,696484,1011562,173823,943571,762642,554703,293709,426185,842015,1013377,471671,54103,303525,596593,986986,246499,171425,812185,210702,897145,797756,288216,949837,78259,525224,196682,1022282,1008901,278406,205960,351125,62019,441622,379451,1040827,819690,517103,635039,578531,424127,484999,479062,947480,262002,204618,864399,394910,451399,449891,441611,396705,402715,614767,419433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]