SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34041 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34041 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32238,675217,912835,555101,377651,788486,680750,721633,551618,101267,786428,282004,214348,546212,116056,225660,73049,257501,1024707,443758,918455,6275,46305,117997,73247,700021,280871,1011390,967475,635380,71035,107983,272822,472101,684573,957423,649550,3987,29061,338275,392231,364639,245716,358334,803537,220575,57850,437312,302346,435149,531928,527527,674619,536182,40690,807111,23457,108127,848913,265200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002073s ]