SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467954 LIMIT 1 [ RunTime:0.001168s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467954 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197618,865228,803098,1045309,925216,464163,966325,222189,756651,246809,701277,654411,833179,458403,478878,1027893,573597,98129,129034,88739,870654,492976,381108,933035,486609,799388,431436,815396,416669,774810,933457,175368,342594,484488,244560,471276,1023988,714224,211281,978037,712702,532315,862833,163194,1025977,914418,1023998,733054,1028013,117520,854724,12208,365330,612160,183847,454048,275103,327064,672825,1042554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]