SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033266 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033266 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170416,439450,473663,374192,825782,286378,420772,980666,647774,672587,342732,977939,80974,561719,864978,81773,897934,820028,421343,512608,271042,548073,747928,1030315,668737,767143,293702,157553,688025,144555,676036,415195,720636,905363,151583,656585,62850,83887,927524,175371,30769,859127,535851,148636,634823,459217,642981,421934,586008,669320,419085,413851,114059,257612,21482,566633,273642,691011,132852,862824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]