SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002939s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 379893 LIMIT 1 [ RunTime:0.002242s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 379893 [ RunTime:0.004473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671425,912882,985457,204575,686790,473620,666535,4985,662646,804780,232618,420996,358433,521223,122963,744256,908457,819889,339813,384656,673115,701616,533858,548023,683120,29525,25786,61183,846945,422642,126842,553562,341230,1013132,924862,282219,675788,393189,109342,801202,644467,83507,48829,994782,67594,989402,475665,615639,427088,382150,180694,856644,966143,407565,85934,547973,1014610,711860,93833,643263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 379893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 379893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]