SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68117 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68117 [ RunTime:0.001415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245523,563939,556668,838424,468787,109954,364378,1013229,602229,847720,628774,487070,278485,818533,151250,208590,272141,556970,963739,354541,209977,458033,1005663,467401,547368,885520,741134,793164,243413,259723,34517,744084,656826,74319,1042595,146335,547709,887723,214356,888293,168123,8920,38054,378694,112906,289624,636730,125017,10903,442135,836916,1032756,787544,495968,564872,65594,891392,392463,811630,277380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]