SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458138 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458138 [ RunTime:0.002546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702623,36890,241653,7112,395237,824772,725912,686282,261616,1013112,678954,641108,86441,194519,315741,654131,832654,337639,89239,896204,142051,841372,907866,824198,639222,406299,430757,615556,527151,429648,212186,1019142,357090,841522,423249,739009,746156,112242,81835,231572,682202,368161,275986,550394,590881,898420,754266,34410,163606,210157,929108,820126,375124,63141,120428,1020573,492695,326447,886114,344817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]