SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506858 LIMIT 1 [ RunTime:0.002343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506858 [ RunTime:0.005736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536602,190488,852466,402144,14158,105168,152835,583058,53591,1037930,605545,838309,284957,380144,570645,683299,584300,4963,410389,4017,388167,570722,55354,836010,313897,155338,505295,308001,627229,933899,633206,89938,815597,467573,532385,899139,151593,448686,785103,711117,712029,241721,645851,1033284,477128,360475,31273,330984,986835,867448,103620,448801,716508,967298,183401,502832,1012390,633946,231973,621794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004128s ]