SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481848 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481848 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111756,405031,402172,788585,957677,462947,358585,264608,94436,318649,170555,856534,445290,779512,908499,375923,1029682,814858,856623,1033688,477863,338742,977658,790439,438485,252719,327061,950081,12914,528811,887279,877748,487384,195665,727739,962109,19846,959993,450515,209100,311134,164624,272947,304000,118023,818040,901213,120419,406721,821858,642192,59160,239865,803106,628627,384502,917389,431920,142700,836462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]