SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197210 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197210 [ RunTime:0.003877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297291,905883,734457,620780,604701,615274,264162,438074,662561,512414,283712,196945,198252,381377,199727,158489,496138,911395,191702,321488,728124,993054,772728,213403,710660,713864,1012109,442126,1026393,968340,763777,955337,92420,421003,142694,616784,721122,383127,10450,197764,152112,221116,103025,272178,313653,741622,196404,662273,234035,812777,318842,99802,561978,832018,857524,1006343,229203,401705,305696,254516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]