SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502435 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502435 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346507,786947,743562,463253,845490,689470,947800,446349,411503,915928,147748,880220,330058,736406,168440,743432,350441,675568,243692,3486,58753,907583,472028,95700,489557,232616,613537,744172,950750,982398,942061,620668,462019,289509,175795,797208,624422,715287,228178,95898,715771,443824,421878,917002,159511,347880,995059,770822,463236,36578,435003,374510,140158,452777,468589,1044993,818456,546364,105209,461836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]