SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351706 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351706 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735545,40111,900124,661428,90316,913061,219039,139488,146141,28830,204800,241914,913066,699905,118153,698693,303929,326022,766765,834915,958991,431525,1027382,63878,650497,168371,187332,766424,941291,1016720,273134,190673,972131,716888,668670,711883,832784,264247,510520,544256,776504,625562,732169,927044,913442,42095,394829,480574,608146,500357,84548,661522,144479,248836,645989,170260,613000,926954,469339,562780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]