SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585075 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585075 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221193,411494,580011,197118,47276,490872,802767,185999,21833,934957,978008,382162,19603,249917,710572,757628,714909,346338,781545,982093,158506,8898,486841,373394,946023,413114,930140,191196,843879,349944,731740,284942,251449,903940,241316,149084,919220,489314,947929,842264,520472,543200,579581,542371,638766,895627,543095,520241,855491,908032,144161,104015,896083,942164,617395,98937,1014936,562476,274621,404572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001318s ]