SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803907 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803907 [ RunTime:0.002655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627005,1036202,913769,856245,817552,297567,667550,1009826,552493,225418,437630,288700,367485,610153,334109,1047818,438479,405152,556120,566243,821777,197948,88834,649147,904456,658292,151137,1000831,83997,263444,309421,644589,894625,142667,183967,460601,81434,497232,456819,868102,774177,765895,246486,813430,500809,88165,921337,780552,1038130,6392,449496,559476,221584,763091,155862,483425,292428,384922,426701,725529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]