SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467458 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467458 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246845,188982,404520,175915,904900,337003,836193,14911,933338,434501,427852,601937,294037,47729,438568,458233,242160,141435,572405,223724,219682,540755,346309,191430,846843,1024846,1038396,425554,294289,938090,154797,364063,327718,781391,56919,786610,25092,305835,847405,701157,623790,542794,94770,932683,80296,921182,179576,742753,933891,66919,949452,92206,780184,967454,115224,844504,7000,213723,707509,921283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001560s ]