SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201584 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201584 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913789,213926,735577,719960,392885,381806,859983,435046,829512,668509,244618,40955,1018083,981278,600790,660662,264396,739226,363230,859343,871212,970796,197520,211586,589761,438473,45492,269788,54552,240058,604528,710133,177455,871130,60157,477113,470059,492454,403732,449967,1028015,634668,1015812,11981,775940,635774,73500,658404,534474,531869,675377,720468,834671,386166,708569,369282,551417,19654,407795,84328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]