SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 8041 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 8041 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312012,50592,312261,653121,363009,292238,609891,504978,295352,186849,719936,612673,1020293,118173,185961,877428,52914,969923,612418,2097,703131,733744,995159,202991,743700,578155,51675,424589,253973,55148,328245,470667,796952,913827,729063,125522,774944,843758,307271,1041384,382672,845319,155557,403600,409365,826059,724370,106433,611549,36949,173079,409042,760107,1010626,1260,153536,709349,588073,349756,385820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 8041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 8041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]