SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267596 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267596 [ RunTime:0.003414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280167,589716,87197,621778,172568,419545,436179,267719,90774,17266,724673,315640,272281,615440,655518,1021271,334830,967084,847614,255157,939368,972230,770288,912799,779015,773003,704805,454163,224827,255984,624819,658864,70980,140347,859792,563267,219671,761050,7817,347580,180357,985042,758906,201187,728295,470888,86475,230553,797740,908994,320340,546103,140008,969271,889688,845061,884180,17356,668196,596755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]