SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519931 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519931 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665241,1030603,1042578,303173,880766,894562,291546,505456,340404,586850,852918,890701,550062,1024351,450382,501274,1039046,30752,796026,349314,450607,925451,190367,140405,671768,311502,60983,455944,388431,813354,33690,617410,826547,414425,470131,715214,961324,698414,3260,5189,539344,10958,476179,1044222,132042,623519,308474,77485,379666,38239,770574,146339,534838,285074,677376,1011277,197386,184388,107577,71856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]