SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433352 LIMIT 1 [ RunTime:0.003221s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433352 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003083,555298,864607,206293,177782,797141,586292,1026913,376751,633431,99001,222809,738618,724585,923259,186365,709444,511951,567511,324542,428360,125545,838979,551473,138997,237985,285070,610124,667319,838888,260021,25637,492741,566064,872902,70365,686806,742666,140102,39103,852055,705534,147920,923395,184618,137657,394722,648748,362789,24337,474337,305550,566629,534824,926274,46846,120798,625047,685142,860070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]