SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141751 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141751 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529003,609943,400297,700989,829896,24610,989424,701699,908270,573175,377057,581449,173790,109708,39378,795507,958864,909137,696972,578386,17432,682154,792473,824609,161135,946068,7894,149445,139234,547502,414460,554240,535813,275975,857285,862689,10993,198441,501022,22694,852379,287459,877876,1005380,612940,304917,192680,657298,336885,268928,324165,102086,187844,92483,940802,155603,724491,239530,925144,191070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]