SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535830 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535830 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768923,404580,790840,243242,599177,183281,768283,947139,864013,834202,934982,614655,450160,334497,428582,695804,1033751,91003,889416,813525,200566,782951,815781,965305,523207,36686,600198,177478,850037,706136,799477,734821,772473,129560,595316,957520,492210,542633,591389,376363,598968,1026305,633360,451991,371070,321913,767251,156920,445477,790132,647248,928885,278107,964561,357948,536518,870308,8730,220756,1021279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]