SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190954 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190954 [ RunTime:0.005698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575426,108557,548415,811297,817456,196624,768138,996913,36075,656710,1003889,702728,702639,988919,34117,711524,190645,128404,412010,695432,1003144,645336,983197,565306,833842,10291,495196,128888,642788,283401,909824,481707,255580,812384,982231,965343,108950,734316,987696,393075,151205,859130,985495,847420,238105,4174,236986,381143,141136,471753,632331,367350,608769,18687,152734,117440,728956,135283,821475,1034078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]