SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396431 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396431 [ RunTime:0.002422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178471,100557,807519,410504,295955,845009,354642,201924,441482,354371,406108,160973,199031,558002,100277,873367,167894,441830,167513,567093,3121,1046951,976421,93834,682805,394084,196884,1036708,404716,685306,487598,954576,546699,144226,229956,825086,593014,496173,832885,964545,527996,524678,644720,411744,670224,848128,875096,110818,359274,715414,816966,582124,525193,888771,52287,260768,27835,930858,661467,555302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]