SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575408 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575408 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488120,790063,841678,783835,65829,595724,827830,431617,703236,198769,968092,239058,377518,813850,703626,332860,583331,363838,44865,388240,417532,685008,199886,699249,345611,680222,269468,911874,25442,854853,321130,1008456,791087,646796,961840,571683,69977,159384,675674,34883,406141,471579,547247,576695,713596,52067,446727,860903,246608,426224,1009207,1037253,891579,719256,162151,1044469,740743,556562,828646,427584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]