SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376045 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376045 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204926,259115,227038,868385,199245,288291,880235,200743,210213,269078,481391,623677,215543,299800,320124,360694,409625,632248,215930,437977,438563,711399,274246,482270,67829,737072,538873,653907,1025890,200354,541486,743678,358750,760607,613363,588786,693340,334557,800092,709195,917368,1037270,185430,512479,494449,758190,83783,893803,494286,18138,662709,212804,859773,991369,400033,341650,638123,67803,596519,1039679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002441s ]