SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 17411 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 17411 [ RunTime:0.003389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5265,914263,1048054,53412,718728,29123,418183,793099,974136,6441,194617,1039128,102695,442999,973049,863184,846277,45009,956256,709670,800415,893452,174186,888784,121789,923920,737756,66177,376951,897339,856016,866366,471220,1042921,592911,579781,422487,567848,685212,689019,125896,889474,843375,160536,551519,899163,616770,120674,975597,651565,867514,551794,998966,864940,672688,300563,735073,516224,1047152,925151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 17411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 17411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]