SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436563 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436563 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600522,197081,370683,270029,589118,3896,1006298,302455,771385,324059,176316,420635,120573,142569,1037896,979583,793801,841662,645215,459387,224307,20958,528754,659315,917752,469071,891494,416338,406895,762337,933285,239319,211463,505102,824431,618845,49342,51210,796323,581367,652301,177902,845493,276093,544463,995244,279008,755931,502638,149326,568988,248019,837532,963079,519115,764177,344675,399830,801818,872126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004135s ]