SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421082 LIMIT 1 [ RunTime:0.002295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421082 [ RunTime:0.005400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207094,700253,667843,470272,654882,31633,258370,371129,622084,623637,74348,677716,393063,957089,451203,111997,161943,918467,244387,15434,551930,346666,599151,244941,883413,108750,138849,28771,451172,1601,157282,750406,282090,1034385,467187,671700,573289,877462,105331,145908,840206,884153,181316,224419,243454,747506,844914,198980,755521,101256,605736,239921,157446,198281,332025,70063,517812,304551,879042,704520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]