SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801610 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801610 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480031,868356,72814,615794,218707,815619,1010677,460274,446601,928478,2297,241679,919110,947584,107969,909432,725955,177687,341344,100373,572916,126061,179545,541801,542187,760988,517944,359164,618072,553823,585826,558378,370207,580511,968704,24644,287035,212730,907095,851038,55619,326311,660244,240618,501538,919758,601626,912820,1026008,337109,990939,68812,160434,634780,182295,50323,58328,830175,350714,631884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]