SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519529 LIMIT 1 [ RunTime:0.002302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519529 [ RunTime:0.006977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698834,556943,697367,829413,540640,706521,333814,289358,391977,1009232,306505,334209,658059,426271,838980,318096,341770,295615,808268,697036,92083,499992,334887,980536,782459,30449,410724,65043,317705,215786,199147,613533,975045,261297,287255,326344,394152,8603,916930,89446,386775,127523,613158,230898,5283,105954,1030305,170560,593940,644837,561559,550890,267202,169755,131454,195436,205300,359618,516448,535069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002185s ]