SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511834 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511834 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68659,780250,128676,485843,954320,1009208,24608,727564,971776,923656,1008083,502270,1025193,821937,244630,786079,958672,91753,851282,579557,682286,205265,452831,323739,849497,72426,817010,368954,892267,294962,881569,83513,127179,927328,362511,450232,883358,753079,449096,124699,141036,1479,12971,634561,497640,147642,15160,698104,69865,1016095,838670,688740,969025,590119,653603,643937,175478,379510,337980,587506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003852s ]