SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414276 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414276 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149849,346376,597960,60623,652204,144756,990232,733649,728360,526184,69638,771730,122841,45638,454493,499758,568805,252721,981752,41326,370914,694170,327191,41217,163672,985148,836081,882918,747597,782380,74175,206165,891392,99656,427775,230556,546561,555516,356811,786720,125470,669352,207581,466786,950691,535582,963867,757664,373187,116898,845506,701428,126372,391024,34247,16620,878727,457021,651625,209934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]