SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502593 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502593 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599380,708703,952693,9639,533437,56314,125388,998377,652970,516839,22481,996910,835798,297109,593456,708871,98773,230103,315140,402497,142068,610296,254907,806002,719257,71041,156607,267400,648546,894242,359722,561743,1017188,627939,175780,928373,1002688,484877,628323,317518,527927,864266,712511,727684,703720,441000,578917,420493,181329,678459,823478,736075,66802,201237,263304,716233,887924,522924,945744,541286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]