SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31708 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31708 [ RunTime:0.002708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287507,244725,743554,806712,451821,681938,461912,652892,460131,478084,612582,362316,790731,341288,186718,281623,294164,251973,943768,841934,229213,796403,98905,603866,52810,637480,282001,458297,772803,669661,742477,332673,1027294,263600,524709,1029712,880747,72573,749995,690526,873351,895689,131530,21354,906854,134277,747519,644733,202052,694858,242201,841719,1012326,661218,85303,320850,95921,618950,570051,840400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]