SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521294 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521294 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715055,256244,71646,1023034,986760,274808,209013,369295,122456,434069,419785,985507,310890,642304,1008120,920980,132855,591631,1003600,80970,1017567,348222,229799,417335,697856,230539,708972,275835,114817,787325,583324,978152,234284,283664,788538,495599,22068,526255,232065,488852,881951,771397,886246,518988,926641,600943,416276,1018085,937114,747316,175595,1012369,791660,269938,527297,420555,631491,68373,220320,805423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002969s ]