SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336160 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336160 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616248,156957,1009931,1020504,131533,52144,201133,911432,121473,660784,552025,750346,272265,680507,574465,41601,690909,380800,191606,658806,205574,209232,509796,92768,747050,541627,793452,415488,284731,878491,963852,913963,628982,1036824,135804,590904,124832,507287,677755,699548,395907,715572,320847,616635,135815,988135,193528,230327,525220,708882,122721,36221,239829,278086,776221,352204,975327,303062,477572,614504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]