SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462813 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462813 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833381,803218,493368,550875,166354,934762,314991,397323,920970,900347,1034473,422843,853651,789304,58797,992127,592474,739016,364807,621275,535388,883041,531383,288974,551708,1013030,60032,899420,152293,360706,373713,323084,491893,1002517,11666,151281,201380,701621,599553,247468,223901,384073,567688,188200,525033,161299,671743,788091,645339,138941,665801,232485,478708,691925,361157,982890,238587,496339,200333,914008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]