SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505206 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505206 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326441,758747,776965,736817,1011350,508762,508140,373533,860605,335835,543740,837703,123072,729430,540046,272788,687272,1046115,192947,91677,483467,609472,122741,90236,9052,61065,667040,720503,895375,910328,1001122,120365,713039,794181,32602,457408,617369,212917,30765,1028556,294214,769065,771617,503544,975863,912464,719717,348886,631170,23081,27489,524963,381776,818372,580263,746422,251185,541726,296131,314733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001138s ]