SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486616 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486616 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337858,46602,216595,463944,454499,1328,555085,299813,1005320,605714,119838,175110,193197,759728,213706,380942,875758,560538,862051,544031,609528,733017,1015631,560470,896636,728499,1040684,1033577,157741,569038,859063,762791,833997,437819,13986,574630,790397,861992,284109,836460,644326,984633,180619,615742,101959,1045831,33283,314126,177137,1032095,386115,94836,633590,630271,929853,589764,975895,871308,905398,288616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]