SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040233 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040233 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328802,422173,156013,984941,387812,809717,580812,567132,634119,473126,103374,97326,150920,745863,890837,755927,344198,991254,744695,380666,15674,642191,522389,900778,31600,312277,906291,180965,1036625,381099,549476,523512,720329,125675,1034999,782584,373000,508085,916448,70881,286216,225950,828404,257234,979902,497082,365277,883229,667912,427407,462196,169259,967272,143775,225287,498627,1032744,864408,1032807,634625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040233 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040233 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]