SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406413 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406413 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861173,69044,651448,202624,382009,262649,856994,498815,516077,69965,63349,255148,279379,953615,514150,697975,1013427,571421,42644,797353,209583,197587,495482,700418,51483,7607,960563,859231,458071,661325,543088,663573,399369,713916,746639,112558,83850,26989,420107,208605,328644,100436,560660,1005237,283826,692922,137987,199500,289553,990051,250797,369128,723018,452884,582830,451298,922308,383155,532983,438313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]