SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040196 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040196 [ RunTime:0.003286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395703,206638,589860,609422,26570,69020,795109,442370,280681,663653,111104,385883,397406,449446,347620,796387,186247,90599,174331,634957,1008340,240641,711798,560235,667392,199776,1031887,57077,693960,537898,970114,350895,113109,648324,236059,707349,1023157,88050,608578,342719,81041,420950,514715,713992,767859,17688,25725,610905,535080,1011706,650816,364062,131107,432503,371521,275244,369165,91205,260668,69262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]