SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526508 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526508 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009646,403107,668627,854264,837746,1008997,917894,987782,400477,875225,294199,609624,395963,1012572,215177,471171,591891,226845,737596,912033,616304,44428,135767,638872,160246,532916,688830,454019,264995,659660,571057,680608,323787,137957,819204,548942,510683,62134,991631,345793,868182,760011,408337,886912,677287,266438,989239,811552,718922,141434,116510,34529,339558,8954,819474,685941,105071,199734,226818,487928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]