SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535483 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535483 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675129,62837,642564,118961,659309,1398,321651,183281,826995,873569,613953,106065,850541,358498,825594,416238,682951,78568,551033,162031,127651,838060,720248,610893,759787,482618,702560,562986,358843,879899,685441,696231,263474,203004,401800,91327,401687,941459,701480,156830,649183,564789,444112,845979,1013046,265739,415125,496737,882226,579682,858147,118716,420009,443014,684583,452757,282066,534607,343808,352740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]