SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445414 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445414 [ RunTime:0.002481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168460,448900,303198,112,63747,229904,500245,10906,461726,576398,519312,718379,726391,215226,70513,444571,16405,445847,822907,814602,181376,145722,376264,450096,490418,954301,972840,96738,1020376,918442,1020820,384736,294413,115247,818086,942682,1021540,158570,946211,393882,637639,405815,226096,155778,844504,2327,375199,56077,447728,889208,299659,347079,884098,53178,903795,959026,305177,457783,68982,643210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]