SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269412 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269412 [ RunTime:0.003917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955818,311884,768733,95823,69847,374535,107147,325453,74111,850778,305781,742406,35913,204999,996552,194521,569292,1023197,696632,740538,408621,837741,1007088,123201,263079,267379,751856,1009428,913712,596711,514738,944204,51459,33140,9169,983386,874215,526834,726650,154506,979779,182571,102546,658751,872744,12748,235256,748611,291044,268224,112388,547296,79712,945835,922588,382892,438376,603298,245515,217520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]