SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036612 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036612 [ RunTime:0.003515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100751,117902,89061,524557,411118,823473,859321,184774,957560,545685,415800,951750,566237,484935,696796,954544,291582,10384,933684,393471,13685,843239,32598,94354,519898,131695,547485,1003040,948373,951279,294017,499411,319493,95443,176858,243361,122220,896874,812414,214935,839178,560685,634522,311364,656521,917410,785722,21380,939365,666987,431608,478888,91765,224545,421981,919093,1029331,195724,281108,775642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]