SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564251 LIMIT 1 [ RunTime:0.002175s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564251 [ RunTime:0.003685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197218,673246,419606,201582,771916,796169,101470,73414,292728,539463,227099,249952,605691,689210,476658,132296,914819,375693,925989,293070,1026668,659576,39465,180945,439643,237811,848666,266457,778151,219717,430334,36240,170160,260048,811102,137062,840659,743065,316681,701504,423463,753045,571794,781969,185921,906650,437148,650338,711561,490697,217060,684680,132512,455550,248227,471348,980144,844088,419507,770189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002059s ]